// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_WIP_MTRL_HIS
// * CreateDate    : 2014-06-05 18:30:22
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:22
// * LastChanger   : 2014-06-05 18:30:22
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class ProdWipMtrlHisTable : TableInfo
    {
		public const string C_TableName = "PROD_WIP_MTRL_HIS";
		
		public const string C_Id = "Id";
		public const string C_Prod_SN = "Prod_SN";
		public const string C_Wo_Id = "Wo_Id";
		public const string C_Prod_Code = "Prod_Code";
		public const string C_Prod_Name = "Prod_Name";
		public const string C_Mtrl_SN = "Mtrl_SN";
		public const string C_Mtrl_Code = "Mtrl_Code";
		public const string C_Mtrl_Name = "Mtrl_Name";
		public const string C_Mtrl_Qty = "Mtrl_Qty";
		public const string C_Mtrl_Status = "Mtrl_Status";
		public const string C_WorkGroup_No = "WorkGroup_No";
		public const string C_WorkGroup_Name = "WorkGroup_Name";
		public const string C_Technic_No = "Technic_No";
		public const string C_Technic_Name = "Technic_Name";
		public const string C_Event_Type = "Event_Type";
		public const string C_Related_No = "Related_No";
		public const string C_Event_Time = "Event_Time";
		public const string C_Remark = "Remark";
		public const string C_Trans_No = "Trans_No";
		public const string C_To_Location_No = "To_Location_No";
		public const string C_From_Location_No = "From_Location_No";
		public const string C_Unit = "Unit";
		public const string C_Lots_No = "Lots_No";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_CREATED_DATE = "CREATED_DATE";
		
		public ProdWipMtrlHisTable()
        {
            _tableName = "PROD_WIP_MTRL_HIS";
        }
		
		protected static ProdWipMtrlHisTable _current;
        public static ProdWipMtrlHisTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new ProdWipMtrlHisTable();

            _current.Add(C_Id, new ColumnInfo(C_Id,"Id", true, typeof(string)));
            _current.Add(C_Prod_SN, new ColumnInfo(C_Prod_SN,"ProdSn", false, typeof(string)));
            _current.Add(C_Wo_Id, new ColumnInfo(C_Wo_Id,"WoId", false, typeof(string)));
            _current.Add(C_Prod_Code, new ColumnInfo(C_Prod_Code,"ProdCode", false, typeof(string)));
            _current.Add(C_Prod_Name, new ColumnInfo(C_Prod_Name,"ProdName", false, typeof(string)));
            _current.Add(C_Mtrl_SN, new ColumnInfo(C_Mtrl_SN,"MtrlSn", false, typeof(string)));
            _current.Add(C_Mtrl_Code, new ColumnInfo(C_Mtrl_Code,"MtrlCode", false, typeof(string)));
            _current.Add(C_Mtrl_Name, new ColumnInfo(C_Mtrl_Name,"MtrlName", false, typeof(string)));
            _current.Add(C_Mtrl_Qty, new ColumnInfo(C_Mtrl_Qty,"MtrlQty", false, typeof(decimal)));
            _current.Add(C_Mtrl_Status, new ColumnInfo(C_Mtrl_Status,"MtrlStatus", false, typeof(string)));
            _current.Add(C_WorkGroup_No, new ColumnInfo(C_WorkGroup_No,"WorkgroupNo", false, typeof(string)));
            _current.Add(C_WorkGroup_Name, new ColumnInfo(C_WorkGroup_Name,"WorkgroupName", false, typeof(string)));
            _current.Add(C_Technic_No, new ColumnInfo(C_Technic_No,"TechnicNo", false, typeof(string)));
            _current.Add(C_Technic_Name, new ColumnInfo(C_Technic_Name,"TechnicName", false, typeof(string)));
            _current.Add(C_Event_Type, new ColumnInfo(C_Event_Type,"EventType", false, typeof(string)));
            _current.Add(C_Related_No, new ColumnInfo(C_Related_No,"RelatedNo", false, typeof(string)));
            _current.Add(C_Event_Time, new ColumnInfo(C_Event_Time,"EventTime", false, typeof(DateTime)));
            _current.Add(C_Remark, new ColumnInfo(C_Remark,"Remark", false, typeof(string)));
            _current.Add(C_Trans_No, new ColumnInfo(C_Trans_No,"TransNo", false, typeof(string)));
            _current.Add(C_To_Location_No, new ColumnInfo(C_To_Location_No,"ToLocationNo", false, typeof(string)));
            _current.Add(C_From_Location_No, new ColumnInfo(C_From_Location_No,"FromLocationNo", false, typeof(string)));
            _current.Add(C_Unit, new ColumnInfo(C_Unit,"Unit", false, typeof(string)));
            _current.Add(C_Lots_No, new ColumnInfo(C_Lots_No,"LotsNo", false, typeof(string)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
			
		}
		
		public ColumnInfo Id
        {
            get { return this[C_Id]; }
        }
		
		public ColumnInfo Prod_SN
        {
            get { return this[C_Prod_SN]; }
        }
		
		public ColumnInfo Wo_Id
        {
            get { return this[C_Wo_Id]; }
        }
		
		public ColumnInfo Prod_Code
        {
            get { return this[C_Prod_Code]; }
        }
		
		public ColumnInfo Prod_Name
        {
            get { return this[C_Prod_Name]; }
        }
		
		public ColumnInfo Mtrl_SN
        {
            get { return this[C_Mtrl_SN]; }
        }
		
		public ColumnInfo Mtrl_Code
        {
            get { return this[C_Mtrl_Code]; }
        }
		
		public ColumnInfo Mtrl_Name
        {
            get { return this[C_Mtrl_Name]; }
        }
		
		public ColumnInfo Mtrl_Qty
        {
            get { return this[C_Mtrl_Qty]; }
        }
		
		public ColumnInfo Mtrl_Status
        {
            get { return this[C_Mtrl_Status]; }
        }
		
		public ColumnInfo WorkGroup_No
        {
            get { return this[C_WorkGroup_No]; }
        }
		
		public ColumnInfo WorkGroup_Name
        {
            get { return this[C_WorkGroup_Name]; }
        }
		
		public ColumnInfo Technic_No
        {
            get { return this[C_Technic_No]; }
        }
		
		public ColumnInfo Technic_Name
        {
            get { return this[C_Technic_Name]; }
        }
		
		public ColumnInfo Event_Type
        {
            get { return this[C_Event_Type]; }
        }
		
		public ColumnInfo Related_No
        {
            get { return this[C_Related_No]; }
        }
		
		public ColumnInfo Event_Time
        {
            get { return this[C_Event_Time]; }
        }
		
		public ColumnInfo Remark
        {
            get { return this[C_Remark]; }
        }
		
		public ColumnInfo Trans_No
        {
            get { return this[C_Trans_No]; }
        }
		
		public ColumnInfo To_Location_No
        {
            get { return this[C_To_Location_No]; }
        }
		
		public ColumnInfo From_Location_No
        {
            get { return this[C_From_Location_No]; }
        }
		
		public ColumnInfo Unit
        {
            get { return this[C_Unit]; }
        }
		
		public ColumnInfo Lots_No
        {
            get { return this[C_Lots_No]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		
		
	}
}

